-- created by kumiler
-- on 2023/4/20 10:34
-- DESC
alter table jms_dim.dim_tab_bulk_cargo_area_record_base_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dim.dim_tab_bulk_cargo_area_record_base_dt;
CREATE external TABLE jms_dim.dim_tab_bulk_cargo_area_record_base_dt
   (    CREATE_DATE timestamp comment "创建时间",
        REGIONAL_DESC string comment "大区名称",
        REGIONAL_ID string comment "大区编码",
        PROVIDER_DESC string comment "省份名称",
        PROVIDER_ID string comment "省份编码",
        AGENT_NAME string comment "代理区名称",
        AGENT_CODE string comment "代理区编码",
        CENTER_NAME string comment "中心名称",
        CENTER_CODE string comment "中心编码",
        CITY_DESC string comment "城市名称",
        CITY_ID string comment "城市编码",
        AREA_DESC string comment "区县名称",
        AREA_ID string comment "区县编码",
        FIRST_TIME string comment "一散时间",
        SECOND_TIME string comment "二散时间",
        DELIVER_OVER_TIME string comment "派件加时",
        DELIVER_SPAN_DAY string comment "派件跨天",
        is_main bigint comment'是否主城区1-是，2-否'
   ) comment "散货班次记录数据"
partitioned by (dt string comment "分区字段yyyy-MM-dd")
STORED AS parquet
LOCATION '/dw/hive/jms_dim.db/external/dim_tab_bulk_cargo_area_record_base_dt'
;